﻿
if not exists(select * from sysobjects where name = 'ERPStore_RewriteUrl' and xtype = 'U')
Begin

	create table dbo.ERPStore_RewriteUrl
	(
		Id int identity(1,1) not null,
		Source varchar(1024) not null,
		Destination varchar(1024) not null,
		CreationDate datetime not null
	)

	alter table ERPStore_RewriteUrl add constraint PK_ERPStore_ERPStore_RewriteUrl primary key nonclustered (Id)

	create unique clustered index IX_ERPStore_RewriteUrl_Source on ERPStore_RewriteUrl(Source)

End
Go
